Instructions

Exercise

Melbourne property prices have taken their biggest hit since 2012, falling by almost 2 per cent in the past three months Jim Malo, Jul 26 2018, Domain

This assignment explores the data provided on Melbourne house prices by Anthony Pino. The goal is to examine whether housing prices have cooled in Melbourne, and help Anthony decide whether it is time to buy a two bedroom apartment in Northcote.

Your tasks

  1. Make a map of Melbourne showing the locations of the properties.

  1. Filter the data to focus only on the records for Northcote units. Make a plot of Price by Date, facetted by number of bedrooms. The main thing to learn from this plot is that there are many missing values for number of bedrooms. Impute the missing values, based on the regression method (covered in class). Make sure your predicted value is an integer. Re-make the plot of Price by Date, facetted by number of bedrooms. Make a description of what you learn from the plot, particularly about the trend of 2 bedroom unit prices in Northcote.

  1. Using the many models approach, fit a linear model for Price on Date, separately for every suburb, for 2 bedroom units. You will need to impute the Bedroom2 variable, in the same way done in the previous question. Collect the model estimates, and also the model fit statistics. What suburb has had the largest increase, which has had the biggest decrease in prices? Which suburbs have the worst fitting models?

  2. Examine the results of the auctions, with the Method variable, across suburbs. Perhaps compute proportion of PI, NB, VB, W, relative to the rest of the categories, by month over the years. The goal here is to determine if the downturn might be indicated by a higher proportion of unsold properties.

  3. Fit a big model!

Grading

Points for the assignment will be based on: